
DECLARE @result int
EXEC @result = xp_cmdshell 'dir C:\BancoUnivers'
IF (@result <> 0)
	Exec master.dbo.xp_cmdshell 'Md C:\BancoUnivers'
go
CREATE DATABASE Universidade
ON PRIMARY
(
  name= 'Univers_Dados1',
  filename='C:\BancoUnivers\Univers_Dados1.mdf',
  size= 10MB,
  maxsize=100MB,
  filegrowth= 10MB
),
FILEGROUP SEGUNDO
(
  name= 'Univers_Dados2',
  filename='C:\BancoUnivers\Univers_Dados2.ndf',
  size= 10MB,
  maxsize=100MB,
  filegrowth= 10MB
)
LOG ON
(
  name= 'Univers_Log',
  filename='C:\BancoUnivers\Univers_Log.ldf',
  size= 1MB,
  maxsize=10MB,
  filegrowth= 1MB
)
go
